IF exists(SELECT * FROM dbo.sysobjects WHERE name='vulLockers' AND xtype='P') 
BEGIN
	DROP PROCEDURE vulLockers
END
GO

create procedure vulLockers
as
insert into lockersTabel(lockerNr)
select n.lockerNr from lockerNummers as n
left join lockersTabel as t
on n.lockerNr=t.lockerNr
where t.lockerNr is null